USE QuizDB
GO
SET IDENTITY_INSERT [GiveAQuiz].[QuizDefinitions] ON
INSERT [GiveAQuiz].[QuizDefinitions] ([Id], [QuizName], [Owner], [Description], [TimeLimitInMinutes]) VALUES (1, N'This is a test quiz', N'3a19fc1b-ac90-4d04-8cdf-492447e39f2b', N'This is an awesome essay quiz.', 20)
INSERT [GiveAQuiz].[QuizDefinitions] ([Id], [QuizName], [Owner], [Description], [TimeLimitInMinutes]) VALUES (2, N'Do You Know Your Silverlight and C#?', N'3a19fc1b-ac90-4d04-8cdf-492447e39f2b', N'This is a sample quiz to check Silverlight developers for basic Silverlight and C# skills.', 0)
SET IDENTITY_INSERT [GiveAQuiz].[QuizDefinitions] OFF
GO

SET IDENTITY_INSERT [GiveAQuiz].[QuestionDefinitions] ON
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData]) VALUES (1, 1, 1, N'GiveAQuiz.Questions.EssayQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'First Question.')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData]) VALUES (2, 2, 1, N'GiveAQuiz.Questions.EssayQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'Second Question.')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData]) VALUES (3, 3, 1, N'GiveAQuiz.Questions.EssayQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'Third Question.')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData]) VALUES (4, 4, 1, N'GiveAQuiz.Questions.EssayQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'Fourth Question.')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (5, 1, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What does XAML stand for?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[XML Application Markup Language]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[Extensible Application Markup Language]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[XML Advanced Markup Language]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Extensible Advanced Markup Language]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What does XAML stand for?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (6, 2, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What''s the difference between visibility and opacity?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[Opacity is whether you can see an item; visibility is whether the code can see an item.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[Opacity is how transparent an item is; visibility is whether the item is whether Silverlight draws an item or not.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Opacity is how transparent an item is; visibility is whether the code can see an item. ]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[There is no difference.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What''s the difference between visibility and opacity?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (7, 3, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="Which of these is not an attached property of Canvas?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[Canvas.Top.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Canvas.ZIndex.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Canvas.Left.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[Canvas.Right.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'Which of these is not an attached property of Canvas?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (8, 4, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What is the default mode of Data Binding?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[OneTime.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[TwoWay.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[OneWay.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Auto.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What is the default mode of Data Binding?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (9, 5, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What is the correct class to use if you want to do work on a background thread?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[Thread class.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[BackgroundWorker class.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[ThreadPool class.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Monitor class.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What is the correct class to use if you want to do work on a background thread?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (10, 6, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="Where are XAML resources stored for use throughout an entire application?">
  <Choices>
    <Choice IsCorrectChoice="true"><![CDATA[App.xaml.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Global.xaml.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Any resource section.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Stored as an assembly resource.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'Where are XAML resources stored for use throughout an entire application?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (11, 7, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="How are Image and Media relative URLs handled differently than other relative URLs in Silverlight?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[They are not handled differently.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[Image and Media URLs are relative to the .xap file.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Image and Media URLs are relative to the website.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Image and Media URLs cannot be relative.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'How are Image and Media relative URLs handled differently than other relative URLs in Silverlight?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (12, 8, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What does the Margin property designate in XAML?">
  <Choices>
    <Choice IsCorrectChoice="true"><![CDATA[The distance from the side of the container from which to draw the element.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[The exact placement of the element.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[The space between the element and any children it has.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[The room between the sides of the Silverlight application and the browser.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What does the Margin property designate in XAML?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (13, 9, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What type of transform would you use to move where an object is being drawn">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[PerspectiveTransform.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[TranslateTransform.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[RotateTransform.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[SkewTransform.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What type of transform would you use to move where an object is being drawn')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (14, 10, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What types of assemblies are not included in the XAP file by default?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[The application''s assembly.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[Assemblies in the Plugin.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Assemblies in the SDK.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What types of assemblies are not included in the XAP file by default?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (15, 11, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="In what folder are Silverlight XAP files placed in a web project by default?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[./Bin]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[The Root folder of the website.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[./ClientBin]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[./XAP]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'In what folder are Silverlight XAP files placed in a web project by default?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (16, 12, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="How are Routed Events bubbled?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[From Outermost elements to innermost elements.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[From Innermost elements to outermost elements.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'How are Routed Events bubbled?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (17, 13, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What is the event that is fired once a MediaElement retrieves all the media metadata (like natural duration)?">
  <Choices>
    <Choice IsCorrectChoice="true"><![CDATA[MediaOpened]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[MediaLoaded]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[FileLoaded]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[MetadataLoaded]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What is the event that is fired once a MediaElement retrieves all the media metadata (like natural duration)?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (18, 14, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="How can you protect secrets in your Silverlight application?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[Use encryption in your Silverlight project.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Use obfuscation in your Silverlight project.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Secrets are protected in Silverlight by default.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[You can''t protect secrets in your Silverlight project.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'How can you protect secrets in your Silverlight application?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (19, 15, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="Why are all the network requests Asynchronous in Silverlight?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[To enable better throughput for network requests?]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[To eliminate the problem of locking up the browser during network requests.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[To multi-thread the network requests.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[To teach developers about Asynchronous networking.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'Why are all the network requests Asynchronous in Silverlight?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (20, 16, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What is the difference between reference types and a value types?">
  <Choices>
    <Choice IsCorrectChoice="true"><![CDATA[References are garbage collected and value types are stored on the stack.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Reference types can become value types, but value types cannot become reference types.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Reference types are cleaned up every method call and value types live for the life of the application.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Reference types have no base class, value types derive from object.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What is the difference between reference types and a value types?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (21, 17, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="How many base classes can a class derive from?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[None.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[One.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Two.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Unlimited.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'How many base classes can a class derive from?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (22, 18, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What is an interface for in C#?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[Defines a class that can be implemented.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Defines a visual element that a user can use.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[Defines a contract that a class must implement.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Defines the common base class for other classes.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What is an interface for in C#?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (23, 19, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What is the ''var'' keyword in C# for?">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[It defines a variable that can take any data.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[It creates a new variant type that can store different types of data.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[It creates a compiler inferred typed variable.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[There is no ''var'' keyword in C#.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What is the ''var'' keyword in C# for?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (24, 20, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What is a delegate?">
  <Choices>
    <Choice IsCorrectChoice="true"><![CDATA[The definition of a method signature.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[A proxy object that can be called by the runtime.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[An event.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[A multicast event.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What is a delegate?')
INSERT [GiveAQuiz].[QuestionDefinitions] ([Id], [SortOrder], [QuizDefinition], [QuestionTypeName], [QuestionData], [QuestionText]) VALUES (25, 21, 2, N'GiveAQuiz.Questions.MultipleChoiceQuestionType, GiveAQuiz.Questions, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null', N'<MultipleChoiceQuestionDefinition QuestionText="What does Shawn Wildermuth think Web 2.0 is all about? (Bonus Question)">
  <Choices>
    <Choice IsCorrectChoice="false"><![CDATA[Social Networking.]]></Choice>
    <Choice IsCorrectChoice="true"><![CDATA[Shiny buttons, rounded corners and drop shadows.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[Faster development time.]]></Choice>
    <Choice IsCorrectChoice="false"><![CDATA[New Media.]]></Choice>
  </Choices>
</MultipleChoiceQuestionDefinition>', N'What does Shawn Wildermuth think Web 2.0 is all about? (Bonus Question)')
SET IDENTITY_INSERT [GiveAQuiz].[QuestionDefinitions] OFF
GO

SET IDENTITY_INSERT [GiveAQuiz].[QuizTakers] ON
INSERT [GiveAQuiz].[QuizTakers] ([Id], [Name], [EMail], [LastVisit]) VALUES (1, N'Shawn Wildermuth', N'foo@anonymous.com', CAST(0x07B8DAA76D9EDE320B AS DateTime2))
SET IDENTITY_INSERT [GiveAQuiz].[QuizTakers] OFF
GO

SET IDENTITY_INSERT [GiveAQuiz].[Quizzes] ON
INSERT [GiveAQuiz].[Quizzes] ([Id], [QuizDefinitionID], [Password], [Name], [IsNameOptional], [StartDate], [EndDate], [HasEnded]) VALUES (1, 1, N'GiveAQuiz', N'Pop Quiz', 0, CAST(0xDE320B00 AS Date), CAST(0x4B340B00 AS Date), 0)
INSERT [GiveAQuiz].[Quizzes] ([Id], [QuizDefinitionID], [Password], [Name], [IsNameOptional], [StartDate], [EndDate], [HasEnded]) VALUES (2, 2, N'ILoveSilverlight', N'Do You Know Silverlight and C#?', 0, '06-01-2010', '06-30-2010', 0)
SET IDENTITY_INSERT [GiveAQuiz].[Quizzes] OFF
GO

SET IDENTITY_INSERT [GiveAQuiz].[QuizResults] ON
INSERT [GiveAQuiz].[QuizResults] ([Id], [Quiz], [QuizTaker]) VALUES (1, 1, 1)
SET IDENTITY_INSERT [GiveAQuiz].[QuizResults] OFF
GO

SET IDENTITY_INSERT [GiveAQuiz].[QuizAnswers] ON
INSERT [GiveAQuiz].[QuizAnswers] ([Id], [QuizResult], [QuestionDefinition], [AnswerData], [AnswerText], [Result], [CorrectAnswerText]) VALUES (1, 1, 1, N'This is an answer.', N'This is an answer.', 'Undetermined', 'N/A')
INSERT [GiveAQuiz].[QuizAnswers] ([Id], [QuizResult], [QuestionDefinition], [AnswerData], [AnswerText], [Result], [CorrectAnswerText]) VALUES (2, 1, 2, N'This is a second answer.', N'This is an answer.', 'Undetermined', 'N/A')
INSERT [GiveAQuiz].[QuizAnswers] ([Id], [QuizResult], [QuestionDefinition], [AnswerData], [AnswerText], [Result], [CorrectAnswerText]) VALUES (3, 1, 3, N'This is a third answer.', N'This is an answer.', 'Undetermined', 'N/A')
INSERT [GiveAQuiz].[QuizAnswers] ([Id], [QuizResult], [QuestionDefinition], [AnswerData], [AnswerText], [Result], [CorrectAnswerText]) VALUES (4, 1, 4, N'This is a fourth question.', N'This is an answer.', 'Undetermined', 'N/A')
SET IDENTITY_INSERT [GiveAQuiz].[QuizAnswers] OFF
GO